﻿<?xml version="1.0" encoding="utf-8" ?>
<Models>

    <Model Name="Member">
        
        <StoredProcedure Name="GetMemberByEmail">
            <Parameters>
                <Parameter  Name="@email" Type="System.Data.SqlDbType.VarChar" >
                </Parameter>
            </Parameters>
        </StoredProcedure>

        <StoredProcedure Name="GetMemberByLoginName">
            <Parameters>
                <Parameter  Name="@loginName" Type="System.Data.SqlDbType.NVarChar" >
                </Parameter>
            </Parameters>
        </StoredProcedure>

        <StoredProcedure Name="GetMembersByFirstName">
            <Parameters>
                <Parameter  Name="@firstName" Type="System.Data.SqlDbType.NVarChar">
                </Parameter>
                
            </Parameters>
        </StoredProcedure>

        <StoredProcedure Name="SaveMember">
            <Parameters>
                <Parameter  Name="@id" Type="System.Data.SqlDbType.Int"  ObjectColumn ="ID" Output="true">
                </Parameter>
                <Parameter  Name="@loginName" Type="System.Data.SqlDbType.NVarChar"  ObjectColumn ="LoginName">
                </Parameter>
                <Parameter  Name="@firstName" Type="System.Data.SqlDbType.NVarChar" ObjectColumn="FirstName">
                </Parameter>
                <Parameter  Name="@lastName" Type="System.Data.SqlDbType.NVarChar" ObjectColumn="LastName">
                </Parameter>
                <Parameter  Name="@email" Type="System.Data.SqlDbType.VarChar" ObjectColumn="Email">
                </Parameter>
                <Parameter  Name="@password" Type="System.Data.SqlDbType.VarChar" ObjectColumn="Password">
                </Parameter>
            </Parameters>
        </StoredProcedure>

        <StoredProcedure Name="UpdateMember">
            <Parameters>            
                <Parameter  Name="@loginName" Type="System.Data.SqlDbType.NVarChar"  ObjectColumn ="LoginName">
                </Parameter>
                <Parameter  Name="@firstName" Type="System.Data.SqlDbType.NVarChar" ObjectColumn="FirstName">
                </Parameter>
                <Parameter  Name="@lastName" Type="System.Data.SqlDbType.NVarChar" ObjectColumn="LastName">
                </Parameter>
                <Parameter  Name="@email" Type="System.Data.SqlDbType.VarChar" ObjectColumn="Email">
                </Parameter>
                <Parameter  Name="@password" Type="System.Data.SqlDbType.VarChar" ObjectColumn="Password">
                </Parameter>
            </Parameters>
        </StoredProcedure>

        <StoredProcedure Name="DeleteMember">
            <Parameters>
                <Parameter  Name="@email" Type="System.Data.SqlDbType.VarChar" ObjectColumn="Email">
                </Parameter>
            </Parameters>
        </StoredProcedure>

    </Model>

</Models>